MS Access File

You can import metadata from MS Access files into a MS Access environment.

To import metadata from MS Access files, follow these steps:

  1. On the Explore tab, click a MS Access environment tile to view its details.
    Alternatively, on the Explore tab, select MS Access option under the Filter By Database Type to view all MS Access environments.
  2. Click Options.
    The available environment options appear.
  3. Click Scan Metadata.

    4. The MS Access Metadata Scan - Step1 page appears.

  4. Drag and drop or use to browse and select the MS Access file.
  5. Use the following scan options:
    Add New
    Use this option to insert new metadata into the environment.
    Update Existing + Add New
    Use this option to update the existing metadata based on tables and columns in the MS Access file.
    Update Existing + Add New + Invalidate
    Use this option to update the existing metadata without deleting it.
    Delete & Reload
    Use this option to delete all the business properties and data dictionary stored as metadata for this environment.
  6. Click .

    7. The MS Access Metadata Scan - Step2 page appears.

  7. Select the required tables.
  8. Click .

    9. The metadata is imported and saved in the environment.